Skip to content
[Jenkins]Jenkins
log in

Failed

Trigger service tests.Adding "Cron Job" Schedule With Non-Unique Start Date Parameter (from org.eclipse.kapua.integration.service.jobScheduling.RunTriggerServiceI9nTest)

Failing for the past 85 builds (Since #827 )
Took 4 min 10 sec.

Error Message

Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
Error Code: 0
Query: DataModifyQuery(sql="/*******************************************************************************
 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
 *
 * This program and the accompanying materials are made
 * available under the terms of the Eclipse Public License 2.0
 * which is available at https://www.eclipse.org/legal/epl-2.0/
 *
 * SPDX-License-Identifier: EPL-2.0
 *
 * Contributors:
 *     Eurotech - initial API and implementation
 *******************************************************************************/

UPDATE act_account SET scope_id = null;

DELETE
FROM act_account
WHERE id NOT IN (1);

DELETE
FROM atht_credential
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));

DELETE
FROM atht_access_token;

DELETE
FROM atht_mfa_option;

DELETE
FROM atht_scratch_code;

DELETE
FROM athz_role
WHERE NOT (scope_id = 1 AND id = 1);

DELETE
FROM athz_role_permission
WHERE NOT (scope_id = 1 AND role_id = 1);

DELETE
FROM dvc_device_connection;

DELETE
FROM dvc_device;

DELETE
FROM dvc_device_event;

DELETE
FROM sys_configuration
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));

DELETE
FROM usr_user
WHERE NOT (scope_id = 1 AND id IN (1, 2));

DELETE
FROM athz_access_info
WHERE NOT (scope_id = 1 AND id IN (1, 2));

DELETE
FROM athz_access_permission
WHERE NOT (scope_id = 1 AND id = 1);

DELETE
FROM athz_access_role
WHERE NOT (scope_id = 1 AND id = 1);

DELETE
FROM athz_domain_actions
WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21);

DELETE
FROM athz_domain
WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21));

DELETE
FROM athz_group;

DELETE
FROM tag_tag;

DELETE
FROM job_job;

DELETE
FROM job_job_execution;

DELETE
FROM job_job_step;

DELETE
FROM job_job_step_definition
WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);

DELETE
FROM job_job_step_definition_properties
WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);

DELETE
FROM job_job_step_properties;

DELETE
FROM job_job_target;

DELETE
FROM schdl_trigger;

DELETE
FROM schdl_trigger_properties;
")

Stacktrace

javax.persistence.PersistenceException: 
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
Error Code: 0
Query: DataModifyQuery(sql="/*******************************************************************************
 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
 *
 * This program and the accompanying materials are made
 * available under the terms of the Eclipse Public License 2.0
 * which is available at https://www.eclipse.org/legal/epl-2.0/
 *
 * SPDX-License-Identifier: EPL-2.0
 *
 * Contributors:
 *     Eurotech - initial API and implementation
 *******************************************************************************/

UPDATE act_account SET scope_id = null;

DELETE
FROM act_account
WHERE id NOT IN (1);

DELETE
FROM atht_credential
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));

DELETE
FROM atht_access_token;

DELETE
FROM atht_mfa_option;

DELETE
FROM atht_scratch_code;

DELETE
FROM athz_role
WHERE NOT (scope_id = 1 AND id = 1);

DELETE
FROM athz_role_permission
WHERE NOT (scope_id = 1 AND role_id = 1);

DELETE
FROM dvc_device_connection;

DELETE
FROM dvc_device;

DELETE
FROM dvc_device_event;

DELETE
FROM sys_configuration
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));

DELETE
FROM usr_user
WHERE NOT (scope_id = 1 AND id IN (1, 2));

DELETE
FROM athz_access_info
WHERE NOT (scope_id = 1 AND id IN (1, 2));

DELETE
FROM athz_access_permission
WHERE NOT (scope_id = 1 AND id = 1);

DELETE
FROM athz_access_role
WHERE NOT (scope_id = 1 AND id = 1);

DELETE
FROM athz_domain_actions
WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21);

DELETE
FROM athz_domain
WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21));

DELETE
FROM athz_group;

DELETE
FROM tag_tag;

DELETE
FROM job_job;

DELETE
FROM job_job_execution;

DELETE
FROM job_job_step;

DELETE
FROM job_job_step_definition
WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);

DELETE
FROM job_job_step_definition_properties
WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);

DELETE
FROM job_job_step_properties;

DELETE
FROM job_job_target;

DELETE
FROM schdl_trigger;

DELETE
FROM schdl_trigger_properties;
")
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:312)
	at org.eclipse.kapua.commons.jpa.ResourceSqlScriptExecutor.executeUpdate(ResourceSqlScriptExecutor.java:106)
	at org.eclipse.kapua.commons.configuration.KapuaConfigurableServiceSchemaUtilsWithResources.scriptSession(KapuaConfigurableServiceSchemaUtilsWithResources.java:52)
	at org.eclipse.kapua.qa.common.DBHelper.deleteAll(DBHelper.java:102)
	at org.eclipse.kapua.qa.common.BasicSteps.afterScenarioDocker(BasicSteps.java:443)
	at org.eclipse.kapua.qa.common.BasicSteps.afterScenarioDockerFull(BasicSteps.java:414)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
Error Code: 0
Query: DataModifyQuery(sql="/*******************************************************************************
 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
 *
 * This program and the accompanying materials are made
 * available under the terms of the Eclipse Public License 2.0
 * which is available at https://www.eclipse.org/legal/epl-2.0/
 *
 * SPDX-License-Identifier: EPL-2.0
 *
 * Contributors:
 *     Eurotech - initial API and implementation
 *******************************************************************************/

UPDATE act_account SET scope_id = null;

DELETE
FROM act_account
WHERE id NOT IN (1);

DELETE
FROM atht_credential
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));

DELETE
FROM atht_access_token;

DELETE
FROM atht_mfa_option;

DELETE
FROM atht_scratch_code;

DELETE
FROM athz_role
WHERE NOT (scope_id = 1 AND id = 1);

DELETE
FROM athz_role_permission
WHERE NOT (scope_id = 1 AND role_id = 1);

DELETE
FROM dvc_device_connection;

DELETE
FROM dvc_device;

DELETE
FROM dvc_device_event;

DELETE
FROM sys_configuration
WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));

DELETE
FROM usr_user
WHERE NOT (scope_id = 1 AND id IN (1, 2));

DELETE
FROM athz_access_info
WHERE NOT (scope_id = 1 AND id IN (1, 2));

DELETE
FROM athz_access_permission
WHERE NOT (scope_id = 1 AND id = 1);

DELETE
FROM athz_access_role
WHERE NOT (scope_id = 1 AND id = 1);

DELETE
FROM athz_domain_actions
WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21);

DELETE
FROM athz_domain
WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21));

DELETE
FROM athz_group;

DELETE
FROM tag_tag;

DELETE
FROM job_job;

DELETE
FROM job_job_execution;

DELETE
FROM job_job_step;

DELETE
FROM job_job_step_definition
WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);

DELETE
FROM job_job_step_definition_properties
WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);

DELETE
FROM job_job_step_properties;

DELETE
FROM job_job_target;

DELETE
FROM schdl_trigger;

DELETE
FROM schdl_trigger_properties;
")
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:318)
	at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:150)
	at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:172)
	at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:349)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:316)
	at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.reconnect(DatasourceAccessor.java:585)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.reconnect(DatabaseAccessor.java:1681)
	at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.incrementCallCount(DatasourceAccessor.java:324)
	at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.beginTransaction(DatasourceAccessor.java:257)
	at org.eclipse.persistence.sessions.server.ClientSession.retryTransaction(ClientSession.java:790)
	at org.eclipse.persistence.internal.sessions.AbstractSession.basicBeginTransaction(AbstractSession.java:753)
	at org.eclipse.persistence.sessions.server.ClientSession.addWriteConnection(ClientSession.java:759)
	at org.eclipse.persistence.sessions.server.ServerSession.acquireClientConnection(ServerSession.java:271)
	at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:284)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:275)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:261)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:317)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:288)
	at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:87)
	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:913)
	at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:812)
	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:3004)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1898)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1880)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1845)
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:302)
	at org.eclipse.kapua.commons.jpa.ResourceSqlScriptExecutor.executeUpdate(ResourceSqlScriptExecutor.java:106)
	at org.eclipse.kapua.commons.configuration.KapuaConfigurableServiceSchemaUtilsWithResources.scriptSession(KapuaConfigurableServiceSchemaUtilsWithResources.java:52)
	at org.eclipse.kapua.qa.common.DBHelper.deleteAll(DBHelper.java:102)
	at org.eclipse.kapua.qa.common.BasicSteps.afterScenarioDocker(BasicSteps.java:443)
	at org.eclipse.kapua.qa.common.BasicSteps.afterScenarioDockerFull(BasicSteps.java:414)
	at jdk.internal.reflect.GeneratedMethodAccessor130.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at io.cucumber.java.Invoker.doInvoke(Invoker.java:66)
	at io.cucumber.java.Invoker.invoke(Invoker.java:24)
	at io.cucumber.java.AbstractGlueDefinition.invokeMethod(AbstractGlueDefinition.java:47)
	at io.cucumber.java.JavaHookDefinition.execute(JavaHookDefinition.java:59)
	at io.cucumber.core.runner.CoreHookDefinition.execute(CoreHookDefinition.java:46)
	at io.cucumber.core.runner.HookDefinitionMatch.runStep(HookDefinitionMatch.java:21)
	at io.cucumber.core.runner.ExecutionMode$1.execute(ExecutionMode.java:10)
	at io.cucumber.core.runner.TestStep.executeStep(TestStep.java:92)
	at io.cucumber.core.runner.TestStep.run(TestStep.java:64)
	at io.cucumber.core.runner.TestCase.run(TestCase.java:110)
	at io.cucumber.core.runner.Runner.runPickle(Runner.java:73)
	at io.cucumber.junit.PickleRunners$NoStepDescriptions.run(PickleRunners.java:151)
	at io.cucumber.junit.FeatureRunner.runChild(FeatureRunner.java:135)
	at io.cucumber.junit.FeatureRunner.runChild(FeatureRunner.java:27)
	at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
	at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
	at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
	at io.cucumber.junit.Cucumber.runChild(Cucumber.java:200)
	at io.cucumber.junit.Cucumber.runChild(Cucumber.java:90)
	at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
	at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
	at io.cucumber.junit.Cucumber$RunCucumber.evaluate(Cucumber.java:235)
	at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
	at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:377)
	at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:284)
	at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:248)
	at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:167)
	at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:456)
	at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:169)
	at org.apache.maven.surefire.booter.ForkedBooter.run(ForkedBooter.java:595)
	at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:581)
Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
	at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
	at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
	at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
	at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
	at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:138)
	... 71 more